UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S4gwBk0ei6vSj30tsMXrMfn9ulkZLx+XcTPsIw7TyvE='
WHERE
key_id = 'b23fa46cfb45e3a45424867ac1b913265143b8d7729ab5e87f189a2e2bcb1261'
AND (
token = 'S4gwBk0ei6vSj30tsMXrMfn9ulkZLx+XcTPsIw7TyvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)