UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VPe8m8hBE279ESdhqeCa+H57T05YobIFPiyZuS+PH6k='
WHERE
key_id = '8d4558d4b11e77f2bd343787dd2d324bd8be92e15a5656644e9af694d5193e4a'
AND (
token = 'VPe8m8hBE279ESdhqeCa+H57T05YobIFPiyZuS+PH6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)