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