UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '186PXQ4iYoVhfijKC7+JarlJFW7w+wz46gKOekYo4X0='
WHERE
key_id = 'd0502f1d8baf56e5e199d88581cb0bb0f917cca59a694571ce9843ba5e894744'
AND (
token = '186PXQ4iYoVhfijKC7+JarlJFW7w+wz46gKOekYo4X0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)