UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tYjpm3knryx3GORVH1ofwLTjc2Tz89+lLWpB9k3ESdA='
WHERE
key_id = 'fe4245abec9b646ce07629e40c54be230e1261af56f000b6c57f6fef30320222'
AND (
token = 'tYjpm3knryx3GORVH1ofwLTjc2Tz89+lLWpB9k3ESdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)