UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNJralZDoTsVOhakfM7LauDvdIh2GVoRiCXXxmz6FtA='
WHERE
key_id = '57e7ef9ca846857072f29f13657bef52aca6e38bbe5382b8da77a41133acb4df'
AND (
token = 'KNJralZDoTsVOhakfM7LauDvdIh2GVoRiCXXxmz6FtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)