UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7WNMYwBva/eWCs/Y63jG06snyJHd6w7CLXwVJjiI58='
WHERE
key_id = 'a1b69861324bc982abd36f4dea70b04801ad1792a4b25207893906f69a153ce0'
AND (
token = 'x7WNMYwBva/eWCs/Y63jG06snyJHd6w7CLXwVJjiI58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)