UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/IYvdTYDZ7L8sVy9dfGXmT3tYfnGfKM5u1yHTJd0XMw='
WHERE
key_id = 'e6d5308c2e171ff1b57f871e26172aa91887bd6bf892731c293a78a7cd761db8'
AND (
token = '/IYvdTYDZ7L8sVy9dfGXmT3tYfnGfKM5u1yHTJd0XMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)