UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8m7P38psOvmuVEojsxcXa8WXx9YHwq8wK/1ksTWArso='
WHERE
key_id = '247e3605e5625753083795ac04add140b55664f64b6a8018557e51bf44b1d120'
AND (
token = '8m7P38psOvmuVEojsxcXa8WXx9YHwq8wK/1ksTWArso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)