UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/jUDXgjcValVxAB9hjl7zKTsMoZjkBn3JDVRyoNfxIc='
WHERE
key_id = '7180fa562be370e5460a830dd18b43455145aa8aa8b9e17223be4bcbf8848e9b'
AND (
token = '/jUDXgjcValVxAB9hjl7zKTsMoZjkBn3JDVRyoNfxIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)