UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2n70Twxc2w2szLLOlNgUD0fZHQgWn4TH2ERnFyz1Mb4='
WHERE
key_id = '0c0b9e1a38ce0c4e121cc68a23ef805a59d6021ecfab902c06a39a1c2d19a4c4'
AND (
token = '2n70Twxc2w2szLLOlNgUD0fZHQgWn4TH2ERnFyz1Mb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)