UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aK99F0W4hEYOufNSJWuLT4YLRhA0xb1uXfjtrOJF9l4='
WHERE
key_id = '0477e2c32bd73051a2c5fbb5a0d4f3e9edd1ed9a121a26441fc47fb85fbed3e1'
AND (
token = 'aK99F0W4hEYOufNSJWuLT4YLRhA0xb1uXfjtrOJF9l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)