UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'er9/v7IZXrNllFl8gMFP1djPowY3x07yaf37+JtLrwg='
WHERE
key_id = '4bfab3fc026df0e6ac627e659dd3266bdadee102ae06bfd1766490a5dea6b76a'
AND (
token = 'er9/v7IZXrNllFl8gMFP1djPowY3x07yaf37+JtLrwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)