UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXHlbgZg5A/FztOhfNoI9xQl+M4gvCFYpEzARU4QV80='
WHERE
key_id = 'ddaa1aa40a3268df9b5a70f0d6cef61a54e0f684a496ad888cf459127bb68fb9'
AND (
token = 'gXHlbgZg5A/FztOhfNoI9xQl+M4gvCFYpEzARU4QV80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)