UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sXCMsy97zD9kf5IBDpYK2X2uSSG4wHhwwcykAw7Hvw='
WHERE
key_id = '5d33b5956ad6f286b36f95affe3f857a9e74becaf03c3b5a2119e1c05a62ad0b'
AND (
token = '0sXCMsy97zD9kf5IBDpYK2X2uSSG4wHhwwcykAw7Hvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)