UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b1NfqofiiWMgJkflD7VF5MmWho5bKKs+0F86cj2Kdwc='
WHERE
key_id = '27cc0154256e3064a123df2a1c8f93656a56c700c4abe796124eeff659c2c6b7'
AND (
token = 'b1NfqofiiWMgJkflD7VF5MmWho5bKKs+0F86cj2Kdwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)