UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0D8UH3PvJaHGT0hvDMVctqG/9uWxQtLJPB7iNIxCYT4='
WHERE
key_id = 'de2d7ce4f2599601a72c730ac77de5de81ddbe3cf930eb561085e9d3ab28421d'
AND (
token = '0D8UH3PvJaHGT0hvDMVctqG/9uWxQtLJPB7iNIxCYT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)