UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wKIhlWiXoB61ShDBLpdyBJJAPjDyj46MhMq4OUNGtvo='
WHERE
key_id = 'a99f484255e11388b3721ed48001cfe57710c68ab3dc3baa435003fa4ad441cf'
AND (
token = 'wKIhlWiXoB61ShDBLpdyBJJAPjDyj46MhMq4OUNGtvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)