UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0GL6T2XH3m9TkhlOEFCfwhqEIn/0h5mv0iZGN7eVGZI='
WHERE
key_id = '959dccadcee66e4f838ce8cfc248c28f52c33f1d35e23f5a0e73597ef3c2604c'
AND (
token = '0GL6T2XH3m9TkhlOEFCfwhqEIn/0h5mv0iZGN7eVGZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)