UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgBh4tg08iQR1C7qmhRD9++40r2dt9PbNHn9Ik93txc='
WHERE
key_id = '48e983c20a5ba956906684aa594e503e7237f812d492badb84ba184d03b0cc45'
AND (
token = 'zgBh4tg08iQR1C7qmhRD9++40r2dt9PbNHn9Ik93txc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)