UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QmzPHxPS70DGc2qOUK/njw4Ro1orurEmC+IKkMTq0z4='
WHERE
key_id = 'f1cf607d57b03451b0371c6a18e963defd41c81e5790fad60d17a9b7349edda4'
AND (
token = 'QmzPHxPS70DGc2qOUK/njw4Ro1orurEmC+IKkMTq0z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)