UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '64BNgamIYnfxls+8gyhimuFm9NxFsFyw089Z7KpTNq4='
WHERE
key_id = 'c2cae3c9f534e4bca3c4e693b6345b8fcba3cf0576c4c97f9239a2f883060ecd'
AND (
token = '64BNgamIYnfxls+8gyhimuFm9NxFsFyw089Z7KpTNq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)