UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yxyuD2e3cZayztjUE7lnJI8trpVi30/79hr0OjnPIwo='
WHERE
key_id = '7b1add39ed28e35888b9d2a219655b9f41857024c39fe3b55f23e44455825af6'
AND (
token = 'yxyuD2e3cZayztjUE7lnJI8trpVi30/79hr0OjnPIwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)