UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHLWoLOeqNiP5xL9AECsZi9QcGr6f+fGz2AIVnJBM+g='
WHERE
key_id = 'eb7b6c354331c2c2ae21da2059e0ceccf697e0ba0ad1037c27f6545a6628bbb0'
AND (
token = 'gHLWoLOeqNiP5xL9AECsZi9QcGr6f+fGz2AIVnJBM+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)