UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HjMfWJ9SzYU2Fg3yFSZsAfiioQ+9vqaLfESUNGjQv5w='
WHERE
key_id = '2d151e29e805242e11351840bd512ee8aff5b71dc5a4812a298c9a72a5b8580c'
AND (
token = 'HjMfWJ9SzYU2Fg3yFSZsAfiioQ+9vqaLfESUNGjQv5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)