UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y7VXsTs6QLjSCAfusbxi3yYAxmykiyAyC/ZT19uyI/4='
WHERE
key_id = 'a7e615437f890c9af324ea6043fcb7ae35b1bae0f5ef519fa5071940862019a0'
AND (
token = 'Y7VXsTs6QLjSCAfusbxi3yYAxmykiyAyC/ZT19uyI/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)