UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mK9iuEjIXc8Z/xppdRaP8KsAVaNxVYSj5ZPhuRWyPQE='
WHERE
key_id = '2b488a1e78d060327f99f8689ff814c97172f4abf9fc69ce9cc68a3011a18efc'
AND (
token = 'mK9iuEjIXc8Z/xppdRaP8KsAVaNxVYSj5ZPhuRWyPQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)