UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A4sVwO8p8ijo6mkckS/oEdGScTXvU8mYfv3Ss9zsbpM='
WHERE
key_id = '187913f2610297e4ad5140c64ac2546d3272e70dff01fccbc504d55d3bb5d3cf'
AND (
token = 'A4sVwO8p8ijo6mkckS/oEdGScTXvU8mYfv3Ss9zsbpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)