UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/tzU+agl+H6zb65FOBvuvGVhfQK0u/VRLX9V+7v/yLA='
WHERE
key_id = '267a13c833a230641fbdbd4305c93a4ecdae7b2aac024b0f8d2d82bee5999144'
AND (
token = '/tzU+agl+H6zb65FOBvuvGVhfQK0u/VRLX9V+7v/yLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)