UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rZMYaybnH0jio41raoDW0hCbjeAL17B8I49W7oPaYGA='
WHERE
key_id = '31ebc8d4bdb5028c2322deecd3d7eb9d172e4e4544cdaf5cba1dfc5c7728d046'
AND (
token = 'rZMYaybnH0jio41raoDW0hCbjeAL17B8I49W7oPaYGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)