UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCBg875G6tK+TcKIt7hiMB6e70bveFPWNP2pnmGJLwM='
WHERE
key_id = 'cf80c04aa417d0c8af36b4cf8b46553e77b9fee760f1b20dbfc5812a78edfa00'
AND (
token = 'BCBg875G6tK+TcKIt7hiMB6e70bveFPWNP2pnmGJLwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)