UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B3Hxjpzj1yOuXeaqJLbvvkkbUiLJewsjqlcJ8kqWyac='
WHERE
key_id = 'd519e51459e3dffea5217846e668d7d7793258dd5427e3e31619ea563e72f194'
AND (
token = 'B3Hxjpzj1yOuXeaqJLbvvkkbUiLJewsjqlcJ8kqWyac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)