UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1zVENaiFbpiHOLLEkkJxL7/F5Tj8MzD19Ov/5gRQLEA='
WHERE
key_id = '1ebc9e54751a0888f5362d41c3383bee6aafd1e3d24584205369cc5993f0390b'
AND (
token = '1zVENaiFbpiHOLLEkkJxL7/F5Tj8MzD19Ov/5gRQLEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)