UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRYg+zJkDhCBWu45acJU2NLr/0qUmjfighC+FvWHi8g='
WHERE
key_id = 'ecb711745a69acc074aabedbc290521777c9223861e8943c10e1eb332b385a9a'
AND (
token = 'pRYg+zJkDhCBWu45acJU2NLr/0qUmjfighC+FvWHi8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)